select distinct
demo.last_name "Last name",
demo.first_name "First name" ,
demo.hin "PHN",
demo.phone "Phone number",
CONCAT( demo.address, ", ", demo.city, ", ", demo.province, ", ", demo.postal) as "Address",
CONCAT( "", "eChart", "" ) AS "eChart",
CONCAT( "", "mFile", "" ) AS "Master File"
from demographic demo
where
demo.provider_no = '{provider_no}' and
demo.email =''
select '%' as provider_no, 'All Providers' as provider
union
select provider_no, concat(last_name,',',first_name,'(',provider_no,')') from provider
where status='1'
and provider_type='doctor'
and ohip_no>1
and ohip_no != 123456
order by provider_no;